Pandas Profiling Report

Dataset statistics

Number of variables	20
Number of observations	455495
Missing cells	143894
Missing cells (%)	1.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	69.5 MiB
Average record size in memory	160.0 B

Variable types

Numeric	9
Categorical	11

Warnings

`Ward_Facility_Code` is highly correlated with `Hospital_code` and 3 other fields	High correlation
`source` is highly correlated with `case_id` and 1 other fields	High correlation
`Hospital_code` is highly correlated with `Ward_Facility_Code` and 3 other fields	High correlation
`case_id` is highly correlated with `source` and 1 other fields	High correlation
`Hospital_region_code` is highly correlated with `Ward_Facility_Code` and 3 other fields	High correlation
`Hospital_type_code` is highly correlated with `Ward_Facility_Code` and 3 other fields	High correlation
`City_Code_Hospital` is highly correlated with `Ward_Facility_Code` and 3 other fields	High correlation
`df_index` is highly correlated with `source` and 1 other fields	High correlation
`Stay` is highly correlated with `source`	High correlation
`Hospital_region_code` is highly correlated with `Hospital_type_code` and 1 other fields	High correlation
`Hospital_type_code` is highly correlated with `Hospital_region_code` and 1 other fields	High correlation
`Ward_Facility_Code` is highly correlated with `Hospital_region_code` and 1 other fields	High correlation
`source` is highly correlated with `Stay`	High correlation
`City_Code_Patient` has 6689 (1.5%) missing values	Missing
`Stay` has 137057 (30.1%) missing values	Missing
`case_id` is uniformly distributed	Uniform
`case_id` has unique values	Unique

Reproduction

Analysis started	2021-05-24 10:58:57.828457
Analysis finished	2021-05-24 11:01:29.731944
Duration	2 minutes and 31.9 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	318438
Distinct (%)	69.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	131930.0164

Minimum	0
Maximum	318437
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.5 MiB

Quantile statistics

Minimum	0
5-th percentile	11387
Q1	56936.5
median	113873
Q3	204563.5
95-th percentile	295662.3
Maximum	318437
Range	318437
Interquartile range (IQR)	147627

Descriptive statistics

Standard deviation	90048.67961
Coefficient of variation (CV)	0.6825488399
Kurtosis	-0.9591527657
Mean	131930.0164
Median Absolute Deviation (MAD)	68188
Skewness	0.454073103
Sum	6.00934628 × 10¹⁰
Variance	8108764699
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2	< 0.1%
105659	2	< 0.1%
119986	2	< 0.1%
122035	2	< 0.1%
124084	2	< 0.1%
126133	2	< 0.1%
128182	2	< 0.1%
130231	2	< 0.1%
99512	2	< 0.1%
101561	2	< 0.1%
Other values (318428)	455475	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	< 0.1%
1	2	< 0.1%
2	2	< 0.1%
3	2	< 0.1%
4	2	< 0.1%
5	2	< 0.1%
6	2	< 0.1%
7	2	< 0.1%
8	2	< 0.1%
9	2	< 0.1%

Value	Count	Frequency (%)
318437	1	< 0.1%
318436	1	< 0.1%
318435	1	< 0.1%
318434	1	< 0.1%
318433	1	< 0.1%
318432	1	< 0.1%
318431	1	< 0.1%
318430	1	< 0.1%
318429	1	< 0.1%
318428	1	< 0.1%

case_id
Real number (ℝ_≥0)

HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	455495
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	227748

Minimum	1
Maximum	455495
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.5 MiB

Quantile statistics

Minimum	1
5-th percentile	22775.7
Q1	113874.5
median	227748
Q3	341621.5
95-th percentile	432720.3
Maximum	455495
Range	455494
Interquartile range (IQR)	227747

Descriptive statistics

Standard deviation	131490.2248
Coefficient of variation (CV)	0.5773496354
Kurtosis	-1.2
Mean	227748
Median Absolute Deviation (MAD)	113874
Skewness	-1.170820996 × 10^-15
Sum	1.037380753 × 10¹¹
Variance	1.728967921 × 10¹⁰
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2049	1	< 0.1%
238369	1	< 0.1%
248620	1	< 0.1%
258859	1	< 0.1%
260906	1	< 0.1%
254761	1	< 0.1%
256808	1	< 0.1%
234279	1	< 0.1%
236326	1	< 0.1%
230181	1	< 0.1%
Other values (455485)	455485	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
455495	1	< 0.1%
455494	1	< 0.1%
455493	1	< 0.1%
455492	1	< 0.1%
455491	1	< 0.1%
455490	1	< 0.1%
455489	1	< 0.1%
455488	1	< 0.1%
455487	1	< 0.1%
455486	1	< 0.1%

Hospital_code
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	32
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.32633509

Minimum	1
Maximum	32
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.5 MiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	11
median	19
Q3	26
95-th percentile	30
Maximum	32
Range	31
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.63403567
Coefficient of variation (CV)	0.4711272401
Kurtosis	-1.138349673
Mean	18.32633509
Median Absolute Deviation (MAD)	7
Skewness	-0.2820898336
Sum	8347554
Variance	74.54657196
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
26	47523	10.4%
23	38220	8.4%
19	30036	6.6%
6	29221	6.4%
11	24827	5.5%
14	24715	5.4%
28	24572	5.4%
27	20243	4.4%
9	16360	3.6%
12	16170	3.5%
Other values (22)	183608	40.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	7460	1.6%
2	7277	1.6%
3	10277	2.3%
4	1749	0.4%
5	7448	1.6%
6	29221	6.4%
7	1871	0.4%
8	5284	1.2%
9	16360	3.6%
10	13538	3.0%

Value	Count	Frequency (%)
32	15252	3.3%
31	5740	1.3%
30	7215	1.6%
29	16158	3.5%
28	24572	5.4%
27	20243	4.4%
26	47523	10.4%
25	14046	3.1%
24	11467	2.5%
23	38220	8.4%

Hospital_type_code
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.5 MiB

a	204730
b	98884
c	66147
e	35428
d	29048
Other values (2)	21258

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	455495
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	c
2nd row	c
3rd row	e
4th row	b
5th row	b

Common Values

Value	Count	Frequency (%)
a	204730	44.9%
b	98884	21.7%
c	66147	14.5%
e	35428	7.8%
d	29048	6.4%
f	15252	3.3%
g	6006	1.3%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
a	204730	44.9%
b	98884	21.7%
c	66147	14.5%
e	35428	7.8%
d	29048	6.4%
f	15252	3.3%
g	6006	1.3%

Most occurring characters

Value	Count	Frequency (%)
a	204730	44.9%
b	98884	21.7%
c	66147	14.5%
e	35428	7.8%
d	29048	6.4%
f	15252	3.3%
g	6006	1.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	455495	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	204730	44.9%
b	98884	21.7%
c	66147	14.5%
e	35428	7.8%
d	29048	6.4%
f	15252	3.3%
g	6006	1.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	455495	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	204730	44.9%
b	98884	21.7%
c	66147	14.5%
e	35428	7.8%
d	29048	6.4%
f	15252	3.3%
g	6006	1.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	455495	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	204730	44.9%
b	98884	21.7%
c	66147	14.5%
e	35428	7.8%
d	29048	6.4%
f	15252	3.3%
g	6006	1.3%

City_Code_Hospital
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.767797671

Minimum	1
Maximum	13
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.5 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	5
Q3	7
95-th percentile	11
Maximum	13
Range	12
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.102450222
Coefficient of variation (CV)	0.6507092869
Kurtosis	-0.6106581387
Mean	4.767797671
Median Absolute Deviation (MAD)	3
Skewness	0.5434124607
Sum	2171708
Variance	9.625197382
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
1	79058	17.4%
2	74312	16.3%
6	67441	14.8%
7	50279	11.0%
3	45544	10.0%
5	44395	9.7%
9	37428	8.2%
11	24572	5.4%
4	19778	4.3%
10	7460	1.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	79058	17.4%
2	74312	16.3%
3	45544	10.0%
4	19778	4.3%
5	44395	9.7%
6	67441	14.8%
7	50279	11.0%
9	37428	8.2%
10	7460	1.6%
11	24572	5.4%

Value	Count	Frequency (%)
13	5228	1.1%
11	24572	5.4%
10	7460	1.6%
9	37428	8.2%
7	50279	11.0%
6	67441	14.8%
5	44395	9.7%
4	19778	4.3%
3	45544	10.0%
2	74312	16.3%

Hospital_region_code
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.5 MiB

X	190849
Y	174707
Z	89939

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	455495
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Z
2nd row	Z
3rd row	X
4th row	Y
5th row	Y

Common Values

Value	Count	Frequency (%)
X	190849	41.9%
Y	174707	38.4%
Z	89939	19.7%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
x	190849	41.9%
y	174707	38.4%
z	89939	19.7%

Most occurring characters

Value	Count	Frequency (%)
X	190849	41.9%
Y	174707	38.4%
Z	89939	19.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	455495	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
X	190849	41.9%
Y	174707	38.4%
Z	89939	19.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	455495	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
X	190849	41.9%
Y	174707	38.4%
Z	89939	19.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	455495	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
X	190849	41.9%
Y	174707	38.4%
Z	89939	19.7%

Available Extra Rooms in Hospital
Real number (ℝ_≥0)

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.196140463

Minimum	0
Maximum	24
Zeros	22
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.5 MiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	2
median	3
Q3	4
95-th percentile	5
Maximum	24
Range	24
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.166993742
Coefficient of variation (CV)	0.3651259247
Kurtosis	2.549561887
Mean	3.196140463
Median Absolute Deviation (MAD)	1
Skewness	0.9589704305
Sum	1455826
Variance	1.361874393
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
2	140895	30.9%
4	131191	28.8%
3	130755	28.7%
5	27602	6.1%
6	11003	2.4%
1	7984	1.8%
7	4107	0.9%
8	1468	0.3%
9	327	0.1%
10	89	< 0.1%
Other values (8)	74	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	22	< 0.1%
1	7984	1.8%
2	140895	30.9%
3	130755	28.7%
4	131191	28.8%
5	27602	6.1%
6	11003	2.4%
7	4107	0.9%
8	1468	0.3%
9	327	0.1%

Value	Count	Frequency (%)
24	1	< 0.1%
21	4	< 0.1%
20	2	< 0.1%
14	1	< 0.1%
13	3	< 0.1%
12	17	< 0.1%
11	24	< 0.1%
10	89	< 0.1%
9	327	0.1%
8	1468	0.3%

Department
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.5 MiB

gynecology	356688
anesthesia	42358
radiotherapy	41033
TB & Chest disease	13751
surgery	1665

Length

Max length	18
Median length	10
Mean length	10.41071581
Min length	7

Characters and Unicode

Total characters	4742029
Distinct characters	21
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	radiotherapy
2nd row	radiotherapy
3rd row	anesthesia
4th row	radiotherapy
5th row	radiotherapy

Common Values

Value	Count	Frequency (%)
gynecology	356688	78.3%
anesthesia	42358	9.3%
radiotherapy	41033	9.0%
TB & Chest disease	13751	3.0%
surgery	1665	0.4%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
gynecology	356688	71.8%
anesthesia	42358	8.5%
radiotherapy	41033	8.3%
	13751	2.8%
disease	13751	2.8%
tb	13751	2.8%
chest	13751	2.8%
surgery	1665	0.3%

Most occurring characters

Value	Count	Frequency (%)
y	756074	15.9%
o	754409	15.9%
g	715041	15.1%
e	525355	11.1%
n	399046	8.4%
c	356688	7.5%
l	356688	7.5%
a	180533	3.8%
s	127634	2.7%
i	97142	2.0%
Other values (11)	473419	10.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4645772	98.0%
Uppercase Letter	41253	0.9%
Space Separator	41253	0.9%
Other Punctuation	13751	0.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
y	756074	16.3%
o	754409	16.2%
g	715041	15.4%
e	525355	11.3%
n	399046	8.6%
c	356688	7.7%
l	356688	7.7%
a	180533	3.9%
s	127634	2.7%
i	97142	2.1%
Other values (6)	377162	8.1%

Uppercase Letter

Value	Count	Frequency (%)
T	13751	33.3%
B	13751	33.3%
C	13751	33.3%

Space Separator

Value	Count	Frequency (%)
	41253	100.0%

Other Punctuation

Value	Count	Frequency (%)
&	13751	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4687025	98.8%
Common	55004	1.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
y	756074	16.1%
o	754409	16.1%
g	715041	15.3%
e	525355	11.2%
n	399046	8.5%
c	356688	7.6%
l	356688	7.6%
a	180533	3.9%
s	127634	2.7%
i	97142	2.1%
Other values (9)	418415	8.9%

Common

Value	Count	Frequency (%)
	41253	75.0%
&	13751	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4742029	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
y	756074	15.9%
o	754409	15.9%
g	715041	15.1%
e	525355	11.1%
n	399046	8.4%
c	356688	7.5%
l	356688	7.5%
a	180533	3.8%
s	127634	2.7%
i	97142	2.0%
Other values (11)	473419	10.0%

Ward_Type
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.5 MiB

R	182939
Q	152046
S	111166
P	7199
T	2133

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	455495
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	R
2nd row	S
3rd row	S
4th row	R
5th row	S

Common Values

Value	Count	Frequency (%)
R	182939	40.2%
Q	152046	33.4%
S	111166	24.4%
P	7199	1.6%
T	2133	0.5%
U	12	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
r	182939	40.2%
q	152046	33.4%
s	111166	24.4%
p	7199	1.6%
t	2133	0.5%
u	12	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
R	182939	40.2%
Q	152046	33.4%
S	111166	24.4%
P	7199	1.6%
T	2133	0.5%
U	12	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	455495	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
R	182939	40.2%
Q	152046	33.4%
S	111166	24.4%
P	7199	1.6%
T	2133	0.5%
U	12	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	455495	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
R	182939	40.2%
Q	152046	33.4%
S	111166	24.4%
P	7199	1.6%
T	2133	0.5%
U	12	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	455495	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
R	182939	40.2%
Q	152046	33.4%
S	111166	24.4%
P	7199	1.6%
T	2133	0.5%
U	12	< 0.1%

Ward_Facility_Code
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.5 MiB

F	161470
E	79058
D	74312
C	50279
B	50116

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	455495
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	F
2nd row	F
3rd row	E
4th row	D
5th row	D

Common Values

Value	Count	Frequency (%)
F	161470	35.4%
E	79058	17.4%
D	74312	16.3%
C	50279	11.0%
B	50116	11.0%
A	40260	8.8%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
f	161470	35.4%
e	79058	17.4%
d	74312	16.3%
c	50279	11.0%
b	50116	11.0%
a	40260	8.8%

Most occurring characters

Value	Count	Frequency (%)
F	161470	35.4%
E	79058	17.4%
D	74312	16.3%
C	50279	11.0%
B	50116	11.0%
A	40260	8.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	455495	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
F	161470	35.4%
E	79058	17.4%
D	74312	16.3%
C	50279	11.0%
B	50116	11.0%
A	40260	8.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	455495	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
F	161470	35.4%
E	79058	17.4%
D	74312	16.3%
C	50279	11.0%
B	50116	11.0%
A	40260	8.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	455495	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
F	161470	35.4%
E	79058	17.4%
D	74312	16.3%
C	50279	11.0%
B	50116	11.0%
A	40260	8.8%

Bed Grade
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	148
Missing (%)	< 0.1%
Memory size	3.5 MiB

2.0	176451
3.0	158942
4.0	82387
1.0	37567

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	1366041
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2.0
2nd row	2.0
3rd row	2.0
4th row	2.0
5th row	2.0

Common Values

Value	Count	Frequency (%)
2.0	176451	38.7%
3.0	158942	34.9%
4.0	82387	18.1%
1.0	37567	8.2%
(Missing)	148	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
2.0	176451	38.8%
3.0	158942	34.9%
4.0	82387	18.1%
1.0	37567	8.3%

Most occurring characters

Value	Count	Frequency (%)
.	455347	33.3%
0	455347	33.3%
2	176451	12.9%
3	158942	11.6%
4	82387	6.0%
1	37567	2.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	910694	66.7%
Other Punctuation	455347	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	455347	50.0%
2	176451	19.4%
3	158942	17.5%
4	82387	9.0%
1	37567	4.1%

Other Punctuation

Value	Count	Frequency (%)
.	455347	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1366041	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	455347	33.3%
0	455347	33.3%
2	176451	12.9%
3	158942	11.6%
4	82387	6.0%
1	37567	2.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1366041	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	455347	33.3%
0	455347	33.3%
2	176451	12.9%
3	158942	11.6%
4	82387	6.0%
1	37567	2.8%

patientid
Real number (ℝ_≥0)

Distinct	131624
Distinct (%)	28.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	65786.79356

Minimum	1
Maximum	131624
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.5 MiB

Quantile statistics

Minimum	1
5-th percentile	6607
Q1	32874
median	65735
Q3	98576.5
95-th percentile	125071.3
Maximum	131624
Range	131623
Interquartile range (IQR)	65702.5

Descriptive statistics

Standard deviation	37968.83085
Coefficient of variation (CV)	0.5771497408
Kurtosis	-1.197556563
Mean	65786.79356
Median Absolute Deviation (MAD)	32852
Skewness	0.003135672615
Sum	2.996555553 × 10¹⁰
Variance	1441632116
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
66714	50	< 0.1%
91292	43	< 0.1%
38525	39	< 0.1%
114456	37	< 0.1%
101359	36	< 0.1%
33491	34	< 0.1%
32886	32	< 0.1%
6645	31	< 0.1%
99644	30	< 0.1%
31203	30	< 0.1%
Other values (131614)	455133	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	4	< 0.1%
2	2	< 0.1%
3	4	< 0.1%
4	2	< 0.1%
5	7	< 0.1%
6	1	< 0.1%
7	4	< 0.1%
8	12	< 0.1%
9	2	< 0.1%
10	2	< 0.1%

Value	Count	Frequency (%)
131624	3	< 0.1%
131623	2	< 0.1%
131622	4	< 0.1%
131621	3	< 0.1%
131620	9	< 0.1%
131619	6	< 0.1%
131618	1	< 0.1%
131617	2	< 0.1%
131616	6	< 0.1%
131615	2	< 0.1%

City_Code_Patient
Real number (ℝ_≥0)

MISSING

Distinct	37
Distinct (%)	< 0.1%
Missing	6689
Missing (%)	1.5%
Infinite	0
Infinite (%)	0.0%
Mean	7.249495328

Minimum	1
Maximum	38
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.5 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	8
Q3	8
95-th percentile	16
Maximum	38
Range	37
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	4.758940953
Coefficient of variation (CV)	0.6564513442
Kurtosis	4.516135526
Mean	7.249495328
Median Absolute Deviation (MAD)	1
Skewness	1.601060026
Sum	3253617
Variance	22.64751899
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
8	176825	38.8%
2	55681	12.2%
1	37772	8.3%
7	33958	7.5%
5	28978	6.4%
4	22044	4.8%
9	16692	3.7%
15	12804	2.8%
10	11809	2.6%
6	8723	1.9%
Other values (27)	43520	9.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	37772	8.3%
2	55681	12.2%
3	5401	1.2%
4	22044	4.8%
5	28978	6.4%
6	8723	1.9%
7	33958	7.5%
8	176825	38.8%
9	16692	3.7%
10	11809	2.6%

Value	Count	Frequency (%)
38	18	< 0.1%
37	78	< 0.1%
36	29	< 0.1%
35	30	< 0.1%
34	96	< 0.1%
33	121	< 0.1%
32	95	< 0.1%
31	67	< 0.1%
30	194	< 0.1%
29	192	< 0.1%

Type of Admission
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.5 MiB

Trauma	217672
Emergency	168363
Urgent	69460

Length

Max length	9
Median length	6
Mean length	7.108879351
Min length	6

Characters and Unicode

Total characters	3238059
Distinct characters	13
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Emergency
2nd row	Trauma
3rd row	Trauma
4th row	Trauma
5th row	Trauma

Common Values

Value	Count	Frequency (%)
Trauma	217672	47.8%
Emergency	168363	37.0%
Urgent	69460	15.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
trauma	217672	47.8%
emergency	168363	37.0%
urgent	69460	15.2%

Most occurring characters

Value	Count	Frequency (%)
r	455495	14.1%
a	435344	13.4%
e	406186	12.5%
m	386035	11.9%
g	237823	7.3%
n	237823	7.3%
T	217672	6.7%
u	217672	6.7%
E	168363	5.2%
c	168363	5.2%
Other values (3)	307283	9.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2782564	85.9%
Uppercase Letter	455495	14.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	455495	16.4%
a	435344	15.6%
e	406186	14.6%
m	386035	13.9%
g	237823	8.5%
n	237823	8.5%
u	217672	7.8%
c	168363	6.1%
y	168363	6.1%
t	69460	2.5%

Uppercase Letter

Value	Count	Frequency (%)
T	217672	47.8%
E	168363	37.0%
U	69460	15.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3238059	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	455495	14.1%
a	435344	13.4%
e	406186	12.5%
m	386035	11.9%
g	237823	7.3%
n	237823	7.3%
T	217672	6.7%
u	217672	6.7%
E	168363	5.2%
c	168363	5.2%
Other values (3)	307283	9.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3238059	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	455495	14.1%
a	435344	13.4%
e	406186	12.5%
m	386035	11.9%
g	237823	7.3%
n	237823	7.3%
T	217672	6.7%
u	217672	6.7%
E	168363	5.2%
c	168363	5.2%
Other values (3)	307283	9.5%

Severity of Illness
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.5 MiB

Moderate	251565
Minor	122735
Extreme	81195

Length

Max length	8
Median length	8
Mean length	7.013381047
Min length	5

Characters and Unicode

Total characters	3194560
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Extreme
2nd row	Extreme
3rd row	Extreme
4th row	Extreme
5th row	Extreme

Common Values

Value	Count	Frequency (%)
Moderate	251565	55.2%
Minor	122735	26.9%
Extreme	81195	17.8%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
moderate	251565	55.2%
minor	122735	26.9%
extreme	81195	17.8%

Most occurring characters

Value	Count	Frequency (%)
e	665520	20.8%
r	455495	14.3%
M	374300	11.7%
o	374300	11.7%
t	332760	10.4%
d	251565	7.9%
a	251565	7.9%
i	122735	3.8%
n	122735	3.8%
E	81195	2.5%
Other values (2)	162390	5.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2739065	85.7%
Uppercase Letter	455495	14.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	665520	24.3%
r	455495	16.6%
o	374300	13.7%
t	332760	12.1%
d	251565	9.2%
a	251565	9.2%
i	122735	4.5%
n	122735	4.5%
x	81195	3.0%
m	81195	3.0%

Uppercase Letter

Value	Count	Frequency (%)
M	374300	82.2%
E	81195	17.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3194560	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	665520	20.8%
r	455495	14.3%
M	374300	11.7%
o	374300	11.7%
t	332760	10.4%
d	251565	7.9%
a	251565	7.9%
i	122735	3.8%
n	122735	3.8%
E	81195	2.5%
Other values (2)	162390	5.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3194560	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	665520	20.8%
r	455495	14.3%
M	374300	11.7%
o	374300	11.7%
t	332760	10.4%
d	251565	7.9%
a	251565	7.9%
i	122735	3.8%
n	122735	3.8%
E	81195	2.5%
Other values (2)	162390	5.1%

Visitors with Patient
Real number (ℝ_≥0)

Distinct	29
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.284229245

Minimum	0
Maximum	32
Zeros	34
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.5 MiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	2
median	3
Q3	4
95-th percentile	6
Maximum	32
Range	32
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.768044196
Coefficient of variation (CV)	0.538343722
Kurtosis	21.82119341
Mean	3.284229245
Median Absolute Deviation (MAD)	1
Skewness	3.225088709
Sum	1495950
Variance	3.125980278
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
2	197734	43.4%
4	113497	24.9%
3	84689	18.6%
6	27011	5.9%
5	13314	2.9%
8	6920	1.5%
7	3556	0.8%
9	1918	0.4%
1	1776	0.4%
10	1632	0.4%
Other values (19)	3448	0.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	34	< 0.1%
1	1776	0.4%
2	197734	43.4%
3	84689	18.6%
4	113497	24.9%
5	13314	2.9%
6	27011	5.9%
7	3556	0.8%
8	6920	1.5%
9	1918	0.4%

Value	Count	Frequency (%)
32	12	< 0.1%
30	26	< 0.1%
29	10	< 0.1%
25	12	< 0.1%
24	99	< 0.1%
23	10	< 0.1%
22	26	< 0.1%
21	24	< 0.1%
20	100	< 0.1%
19	21	< 0.1%

Age
Categorical

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.5 MiB

41-50	91495
31-40	90420
51-60	69506
21-30	58560
71-80	50737
Other values (5)	94777

Length

Max length	6
Median length	5
Mean length	4.984120572
Min length	4

Characters and Unicode

Total characters	2270242
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	51-60
2nd row	51-60
3rd row	51-60
4th row	51-60
5th row	51-60

Common Values

Value	Count	Frequency (%)
41-50	91495	20.1%
31-40	90420	19.9%
51-60	69506	15.3%
21-30	58560	12.9%
71-80	50737	11.1%
61-70	48619	10.7%
11-20	23871	5.2%
81-90	11240	2.5%
0-10	9140	2.0%
91-100	1907	0.4%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
41-50	91495	20.1%
31-40	90420	19.9%
51-60	69506	15.3%
21-30	58560	12.9%
71-80	50737	11.1%
61-70	48619	10.7%
11-20	23871	5.2%
81-90	11240	2.5%
0-10	9140	2.0%
91-100	1907	0.4%

Most occurring characters

Value	Count	Frequency (%)
1	481273	21.2%
0	466542	20.6%
-	455495	20.1%
4	181915	8.0%
5	161001	7.1%
3	148980	6.6%
6	118125	5.2%
7	99356	4.4%
2	82431	3.6%
8	61977	2.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1814747	79.9%
Dash Punctuation	455495	20.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	481273	26.5%
0	466542	25.7%
4	181915	10.0%
5	161001	8.9%
3	148980	8.2%
6	118125	6.5%
7	99356	5.5%
2	82431	4.5%
8	61977	3.4%
9	13147	0.7%

Dash Punctuation

Value	Count	Frequency (%)
-	455495	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2270242	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	481273	21.2%
0	466542	20.6%
-	455495	20.1%
4	181915	8.0%
5	161001	7.1%
3	148980	6.6%
6	118125	5.2%
7	99356	4.4%
2	82431	3.6%
8	61977	2.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2270242	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	481273	21.2%
0	466542	20.6%
-	455495	20.1%
4	181915	8.0%
5	161001	7.1%
3	148980	6.6%
6	118125	5.2%
7	99356	4.4%
2	82431	3.6%
8	61977	2.7%

Admission_Deposit
Real number (ℝ_≥0)

Distinct	7634
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4877.434022

Minimum	1800
Maximum	11920
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.5 MiB

Quantile statistics

Minimum	1800
5-th percentile	3360
Q1	4184
median	4738
Q3	5405
95-th percentile	6918
Maximum	11920
Range	10120
Interquartile range (IQR)	1221

Descriptive statistics

Standard deviation	1084.982089
Coefficient of variation (CV)	0.2224493625
Kurtosis	1.854782006
Mean	4877.434022
Median Absolute Deviation (MAD)	603
Skewness	0.9313474371
Sum	2221646810
Variance	1177186.134
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4469	445	0.1%
4277	427	0.1%
4624	408	0.1%
4789	378	0.1%
4400	340	0.1%
4807	333	0.1%
4970	332	0.1%
4465	328	0.1%
4603	309	0.1%
4579	306	0.1%
Other values (7624)	451889	99.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1800	2	< 0.1%
1801	2	< 0.1%
1802	2	< 0.1%
1805	2	< 0.1%
1806	1	< 0.1%
1807	1	< 0.1%
1809	1	< 0.1%
1810	1	< 0.1%
1811	2	< 0.1%
1813	2	< 0.1%

Value	Count	Frequency (%)
11920	1	< 0.1%
11293	1	< 0.1%
11008	4	< 0.1%
10999	2	< 0.1%
10842	1	< 0.1%
10841	2	< 0.1%
10793	1	< 0.1%
10785	1	< 0.1%
10771	1	< 0.1%
10729	4	< 0.1%

Stay
Categorical

HIGH CORRELATION
MISSING

Distinct	11
Distinct (%)	< 0.1%
Missing	137057
Missing (%)	30.1%
Memory size	3.5 MiB

21-30	87491
11-20	78139
31-40	55159
51-60	35018
0-10	23604
Other values (6)	39027

Length

Max length	18
Median length	5
Mean length	5.207387309
Min length	4

Characters and Unicode

Total characters	1658230
Distinct characters	23
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0-10
2nd row	41-50
3rd row	31-40
4th row	41-50
5th row	41-50

Common Values

Value	Count	Frequency (%)
21-30	87491	19.2%
11-20	78139	17.2%
31-40	55159	12.1%
51-60	35018	7.7%
0-10	23604	5.2%
41-50	11743	2.6%
71-80	10254	2.3%
More than 100 Days	6683	1.5%
81-90	4838	1.1%
91-100	2765	0.6%
(Missing)	137057	30.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
21-30	87491	25.8%
11-20	78139	23.1%
31-40	55159	16.3%
51-60	35018	10.3%
0-10	23604	7.0%
41-50	11743	3.5%
71-80	10254	3.0%
days	6683	2.0%
100	6683	2.0%
more	6683	2.0%
Other values (4)	17030	5.0%

Most occurring characters

Value	Count	Frequency (%)
1	399342	24.1%
0	351490	21.2%
-	311755	18.8%
2	165630	10.0%
3	142650	8.6%
4	66902	4.0%
5	46761	2.8%
6	37762	2.3%
	20049	1.2%
8	15092	0.9%
Other values (13)	100797	6.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1246230	75.2%
Dash Punctuation	311755	18.8%
Lowercase Letter	66830	4.0%
Space Separator	20049	1.2%
Uppercase Letter	13366	0.8%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	399342	32.0%
0	351490	28.2%
2	165630	13.3%
3	142650	11.4%
4	66902	5.4%
5	46761	3.8%
6	37762	3.0%
8	15092	1.2%
7	12998	1.0%
9	7603	0.6%

Lowercase Letter

Value	Count	Frequency (%)
a	13366	20.0%
o	6683	10.0%
r	6683	10.0%
e	6683	10.0%
t	6683	10.0%
h	6683	10.0%
n	6683	10.0%
y	6683	10.0%
s	6683	10.0%

Uppercase Letter

Value	Count	Frequency (%)
M	6683	50.0%
D	6683	50.0%

Dash Punctuation

Value	Count	Frequency (%)
-	311755	100.0%

Space Separator

Value	Count	Frequency (%)
	20049	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1578034	95.2%
Latin	80196	4.8%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	399342	25.3%
0	351490	22.3%
-	311755	19.8%
2	165630	10.5%
3	142650	9.0%
4	66902	4.2%
5	46761	3.0%
6	37762	2.4%
	20049	1.3%
8	15092	1.0%
Other values (2)	20601	1.3%

Latin

Value	Count	Frequency (%)
a	13366	16.7%
M	6683	8.3%
o	6683	8.3%
r	6683	8.3%
e	6683	8.3%
t	6683	8.3%
h	6683	8.3%
n	6683	8.3%
D	6683	8.3%
y	6683	8.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1658230	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	399342	24.1%
0	351490	21.2%
-	311755	18.8%
2	165630	10.0%
3	142650	8.6%
4	66902	4.0%
5	46761	2.8%
6	37762	2.3%
	20049	1.2%
8	15092	0.9%
Other values (13)	100797	6.1%

source
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.5 MiB

train	318438
test	137057

Length

Max length	5
Median length	5
Mean length	4.699103173
Min length	4

Characters and Unicode

Total characters	2140418
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	train
2nd row	train
3rd row	train
4th row	train
5th row	train

Common Values

Value	Count	Frequency (%)
train	318438	69.9%
test	137057	30.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
train	318438	69.9%
test	137057	30.1%

Most occurring characters

Value	Count	Frequency (%)
t	592552	27.7%
r	318438	14.9%
a	318438	14.9%
i	318438	14.9%
n	318438	14.9%
e	137057	6.4%
s	137057	6.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2140418	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	592552	27.7%
r	318438	14.9%
a	318438	14.9%
i	318438	14.9%
n	318438	14.9%
e	137057	6.4%
s	137057	6.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2140418	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	592552	27.7%
r	318438	14.9%
a	318438	14.9%
i	318438	14.9%
n	318438	14.9%
e	137057	6.4%
s	137057	6.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2140418	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	592552	27.7%
r	318438	14.9%
a	318438	14.9%
i	318438	14.9%
n	318438	14.9%
e	137057	6.4%
s	137057	6.4%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	df_index	case_id	Hospital_code	Hospital_type_code	City_Code_Hospital	Hospital_region_code	Available Extra Rooms in Hospital	Department	Ward_Type	Ward_Facility_Code	Bed Grade	patientid	City_Code_Patient	Type of Admission	Severity of Illness	Visitors with Patient	Age	Admission_Deposit	Stay	source
0	0	1	8	c	3	Z	3	radiotherapy	R	F	2.0	31397	7.0	Emergency	Extreme	2	51-60	4911.0	0-10	train
1	1	2	2	c	5	Z	2	radiotherapy	S	F	2.0	31397	7.0	Trauma	Extreme	2	51-60	5954.0	41-50	train
2	2	3	10	e	1	X	2	anesthesia	S	E	2.0	31397	7.0	Trauma	Extreme	2	51-60	4745.0	31-40	train
3	3	4	26	b	2	Y	2	radiotherapy	R	D	2.0	31397	7.0	Trauma	Extreme	2	51-60	7272.0	41-50	train
4	4	5	26	b	2	Y	2	radiotherapy	S	D	2.0	31397	7.0	Trauma	Extreme	2	51-60	5558.0	41-50	train
5	5	6	23	a	6	X	2	anesthesia	S	F	2.0	31397	7.0	Trauma	Extreme	2	51-60	4449.0	11-20	train
6	6	7	32	f	9	Y	1	radiotherapy	S	B	3.0	31397	7.0	Emergency	Extreme	2	51-60	6167.0	0-10	train
7	7	8	23	a	6	X	4	radiotherapy	Q	F	3.0	31397	7.0	Trauma	Extreme	2	51-60	5571.0	41-50	train
8	8	9	1	d	10	Y	2	gynecology	R	B	4.0	31397	7.0	Trauma	Extreme	2	51-60	7223.0	51-60	train
9	9	10	10	e	1	X	2	gynecology	S	E	3.0	31397	7.0	Trauma	Extreme	2	51-60	6056.0	31-40	train

Last rows

	df_index	case_id	Hospital_code	Hospital_type_code	City_Code_Hospital	Hospital_region_code	Available Extra Rooms in Hospital	Department	Ward_Type	Ward_Facility_Code	Bed Grade	patientid	City_Code_Patient	Type of Admission	Severity of Illness	Visitors with Patient	Age	Admission_Deposit	Stay	source
455485	137047	455486	9	d	5	Z	2	gynecology	S	F	4.0	55235	4.0	Emergency	Moderate	3	31-40	4418.0	NaN	test
455486	137048	455487	13	a	5	Z	2	gynecology	R	F	3.0	55235	4.0	Emergency	Moderate	2	31-40	3816.0	NaN	test
455487	137049	455488	12	a	9	Y	6	gynecology	Q	B	2.0	99515	7.0	Emergency	Moderate	4	61-70	4406.0	NaN	test
455488	137050	455489	13	a	5	Z	3	gynecology	R	F	3.0	22878	21.0	Emergency	Moderate	3	21-30	4573.0	NaN	test
455489	137051	455490	15	c	5	Z	2	gynecology	S	F	4.0	118215	6.0	Urgent	Minor	2	21-30	5241.0	NaN	test
455490	137052	455491	11	b	2	Y	4	anesthesia	Q	D	3.0	41160	3.0	Emergency	Minor	4	41-50	6313.0	NaN	test
455491	137053	455492	25	e	1	X	2	radiotherapy	R	E	4.0	30985	7.0	Emergency	Moderate	2	0-10	3510.0	NaN	test
455492	137054	455493	30	c	3	Z	2	anesthesia	R	A	4.0	81811	12.0	Urgent	Minor	2	0-10	7190.0	NaN	test
455493	137055	455494	5	a	1	X	2	anesthesia	R	E	4.0	57021	10.0	Trauma	Minor	2	41-50	5435.0	NaN	test
455494	137056	455495	6	a	6	X	3	gynecology	Q	F	4.0	126729	3.0	Trauma	Extreme	5	51-60	4702.0	NaN	test

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts